﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE dbo.UpdatePrUnitName
	@NSI_PU_ID int
AS
BEGIN
	DECLARE @ReturnVal int
	DECLARE @NewName nvarchar(50)
	
	SET @ReturnVal = 0
	
	SELECT @NewName = SHORT_NAME FROM NSI_PRODUCT WHERE ID=@NSI_PU_ID
	
	UPDATE PRODUCT_UNIT SET NAME = @NewName WHERE NSI_PRODUCT_ID = @NSI_PU_ID
END